SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+government +deals' IN BOOLEAN MODE)) AND iCityID IN (14864,14856,14874,14853,14872,14882,14886,14862,14891,14846,14869,14884,14878,14850,14880,14847,14845,14858,14871,14859,14868,14857,14890,14861,14852,14875,14877,14876,14198,14854,14332,14879,14883,16373,14272,14283,14294,14199,14328,14331,14848,14231,14244,14338,14855,16600,14318,14340,14222,14335,14195,15934,14187,16370,14194,14189,14860,14341,14230,15896,14236) ORDER BY FIELD(iCityID, 14864,14856,14874,14853,14872,14882,14886,14862,14891,14846,14869,14884,14878,14850,14880,14847,14845,14858,14871,14859,14868,14857,14890,14861,14852,14875,14877,14876,14198,14854,14332,14879,14883,16373,14272,14283,14294,14199,14328,14331,14848,14231,14244,14338,14855,16600,14318,14340,14222,14335,14195,15934,14187,16370,14194,14189,14860,14341,14230,15896,14236) ASC, p.tmPosted DESC LIMIT 24 government deals, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Greeley

Items for sale in Greeley - government deals

No results found!

Looking for something? Get notified when it's posted. Setup an Email Alert now!

Greeley

Items for Sale

Items for sale in Greeley - government deals

Similar searches: